Transporter Extraction

transport_task_main_details

Column	Type	Description
transport_task_main_detail_id	int64	Primary key of the transport task (transport_tasks.id).
business_group_id	int64	Business group id (via tenancy → company → business_group_id).
tenancy_id	int64	Tenant id (organizational unit / department in the app; row in tenancies) the task belongs to.
driver_collaborator_id	int64	Driver (collaborator) id on the task group (transport_task_groups.driver_collaborator_id).
vehicle_id	int64	Vehicle id used on the route (transport_task_groups.vehicle_id).
customer_company_id	int64	Customer company id (generator / collection side).
recycler_company_id	int64	Recycler / destination company id.
transporter_company_id	int64	Carrier company id responsible for the task group.
customer_company_name	string	Customer trade name (alias_name).
customer_company_cpf_cnpj	string	Customer company tax id (CPF/CNPJ) as stored.
formatted_customer_company_cpf_cnpj	string	Customer company tax id formatted for display.
customer_company_state	string	Customer state (UF) from the main address.
customer_company_city	string	Customer city from the main address.
recycler_company_name	string	Recycler trade name.
recycler_company_cpf_cnpj	string	Recycler tax id as stored.
formatted_recycler_company_cpf_cnpj	string	Recycler tax id formatted.
transporter_company_name	string	Carrier trade name.
transporter_company_cpf_cnpj	string	Carrier tax id as stored.
formatted_transporter_company_cpf_cnpj	string	Carrier tax id formatted.
contract_number	string	Contract identifier (contract_identification).
transport_route_name	string	Transport route name linked to the task group.
task_type_name	string	Transport task type name.
task_type_description	string	Task type description.
current_state	string	Current task state type (currentTransportTaskState.type).
task_type	string	Task type record type field.
task_subtype	string	Task subtype.
task_recurrence_type	string	Group recurrence frequency (system_recurrence.frequency_type).
task_recurrence_description	string	Human-readable recurrence rule (from MakeSystemRecurrenceDescriptionAction).
status_mtrs	string	Disposal status rendered as text (e.g. in transit, received — wording follows app locale in the DTO).
waste_movement_ids	string	Comma-separated waste movement ids from the linked disposal, if any.
mtrs	string	MTR (waste transport manifest) codes tied to the disposal, prefixed by schema (e.g. SIGOR-12345).
schemas	string	Manifest schemas (integration source) for waste transport manifests.
current_total_packing	double	Total packings in the current state (sum of transporter packing quantities, rounded up).
waste_total_kg_quantity	double	Total waste mass in kg for items in the current state (excludes “not executed” lines).
task_type_is_default	boolean	Whether the task type is a global default (true when the type has no tenancy_id).
task_is_urgent	boolean	Whether the task is flagged urgent in configuration.
is_next_on_group	boolean	Whether this is the next task in the group.
is_under_processing	boolean	Whether the task is under processing (special rules in extraction).
is_recurrence_base	boolean	Whether the group is a recurrence base (extraction usually filters is_recurrence_base = false).
downloaded_from_app_at	dateTime	When the record was downloaded to the carrier mobile app.
uploaded_from_app_at	dateTime	When data was uploaded from the app.
current_executed_at	dateTime	Execution timestamp for the current task state.
updated_at	dateTime	Last update of the task at source.
deleted_at	dateTime	Soft delete timestamp of the task.

---

transport_task_state_item_details

Columns are grouped by logical type (Parquet: int64 / string / double / boolean / dateTime).

Column	Type	Description
transport_task_state_item_detail_id	int64	Synthetic key: numeric concatenation of transport_task_id and the item index (lakehouse-specific id).
transport_task_main_detail_id	int64	Parent transport task id (transport_tasks.id).
tenancy_id	int64	Tenant id (organizational unit / department; tenancies.id) for the task.
business_group_id	int64	Business group id (via tenant → company).
index	int64	Item order within the task (TransportTaskStateItem index).
programming_waste_id	int64	Waste id referenced on the transport content (programming).
programming_packing_id	int64	Transporter packing id (programming).
justification_waste_id	int64	Waste id (justification).
justification_packing_id	int64	Packing id (justification).
not_execution_waste_id	int64	Waste id (not execution).
not_execution_packing_id	int64	Packing id (not execution).
solicitation_waste_id	int64	Waste id (solicitation).
solicitation_packing_id	int64	Packing id (solicitation).
confirmation_waste_id	int64	Waste id (confirmation).
confirmation_packing_id	int64	Packing id (confirmation).
item_current_state	string	Task current state type at build time (mirrors the task’s current state).
deviation	string	Deviation in minutes between scheduled and actual times (capped at 24h in some cases); see getItemDeviation in the DTO.
justification_item_type	string	Justification type when the item state is Justification (justification_type).
programming_address	string	Street line of the address on the state (programming).
justification_address	string	Street line (justification).
not_execution_address	string	Street line (not execution).
solicitation_address	string	Street line (solicitation).
confirmation_address	string	Street line (confirmation).
justification_item_observation	string	Free-text note in the Justification state (observation).
not_execution_justification	string	Note when the state is Not execution (observation).
programming_packing_quantity	double	Packing quantity (programming).
programming_packing_tare_weight	double	Packing tare weight in kg (programming).
programming_waste_quantity	double	Waste quantity in the content unit (programming).
programming_waste_kg_quantity	double	Waste quantity in kg (programming).
programming_waste_gross_quantity	double	Gross waste quantity (programming).
justification_packing_quantity	double	Packing quantity (justification).
justification_packing_tare_weight	double	Packing tare weight (justification).
justification_waste_quantity	double	Waste quantity (justification).
justification_waste_kg_quantity	double	Waste quantity in kg (justification).
justification_waste_gross_quantity	double	Gross waste quantity (justification).
not_execution_packing_quantity	double	Packing quantity (not execution).
not_execution_packing_tare_weight	double	Tare weight (not execution).
not_execution_waste_quantity	double	Waste quantity (not execution).
not_execution_waste_kg_quantity	double	Waste quantity in kg (not execution).
not_execution_waste_gross_quantity	double	Gross waste quantity (not execution).
solicitation_packing_quantity	double	Packing quantity (solicitation).
solicitation_packing_tare_weight	double	Tare weight (solicitation).
solicitation_waste_quantity	double	Waste quantity (solicitation).
solicitation_waste_kg_quantity	double	Waste quantity in kg (solicitation).
solicitation_waste_gross_quantity	double	Gross waste quantity (solicitation).
confirmation_packing_quantity	double	Packing quantity (confirmation).
confirmation_packing_tare_weight	double	Tare weight (confirmation).
confirmation_waste_quantity	double	Waste quantity (confirmation).
confirmation_waste_kg_quantity	double	Waste quantity in kg (confirmation).
confirmation_waste_gross_quantity	double	Gross waste quantity (confirmation).
is_not_executed	boolean	true when the line justification is not executed.
programming_date	dateTime	State executed-at timestamp (programming).
justification_date	dateTime	State executed-at (justification).
not_execution_date	dateTime	State executed-at (not execution).
solicitation_date	dateTime	State executed-at (solicitation).
confirmation_date	dateTime	State executed-at (confirmation).
updated_at	dateTime	Last update of the task state (transport_task_states.updated_at) used for this row.
deleted_at	dateTime	Soft delete of the task state (transport_task_states.deleted_at).